﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'DeleteDetalleOrdenCompra')
	BEGIN
		DROP  Procedure  DeleteDetalleOrdenCompra
	END

GO

CREATE Procedure DeleteDetalleOrdenCompra
	@idBien int,
	@idOrdenCompra int,
	@cantidad decimal(8,4)
AS

BEGIN
	SET NOCOUNT ON
	
	DELETE FROM DetalleOrdenCompra WHERE IdBien=@idBien AND IdOrdenCompra=@idOrdenCompra
    
    SET NOCOUNT OFF
END

GO


GRANT EXEC ON DeleteDetalleOrdenCompra TO PUBLIC

GO

